{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Convert Text","Upper Lower Proper","Sumif Countif Averageif","IF AND","IF OR"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Convert Text","index":0,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Last","Street","City","State","Zip"]
["Bob Martin","9234 Hansford Rd.","Brighton","NY",14838]
["Fiona Banks","13 Emerald Rd.","Brighton","NY",14838]
["Frank Cefalu","832 Brendon Ln.","Brighton","NY",14838]
["Karen Hughes","92 Cypress St.","Irondequoit","NY",14925]
["Kevin Hardy","1924 Necco Pl.","Irondequoit","NY",14925]
["Bill Wagner","9245 Wallace St.","Pittsford","NY",14832]
["Gerard Peters","9342 Hilder Rd.","Pittsford","NY",14832]
["Ken Hardy","19 Grenada","Pittsford","NY",14832]
["Kevin Campbell","125 Trudy Dr.","Rochester","NY",14637]
["Meg Jones","43 Corwin St.","Rochester","NY",14637]
["Sally Hurlbutt","9210 Prener St.","Rochester","NY",14637]

{"sheet":"Upper Lower Proper","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["First:","Last:","Status:","Member ID:"]
["TOM","SMITH","RETURNING MEMBER","b942d"]
["TIM","JONES","NEW MEMBER","c028g"]
["SAM","PETERS","RETURNING MEMBER","r549c"]
["Pamela","WILLIAMS","RETURNING MEMBER","u429h"]
["LINDA","STREETMAN","NEW MEMBER","p938q"]
["RAE","HORNE","RETURNING MEMBER","t395h"]
["PATTI","PAGE","NEW MEMBER","w392y"]
["PAMELA","ABERCROMBIE","NEW MEMBER","u399e"]
["LORNA","PACKARD","RETURNING MEMBER","s291f"]

{"sheet":"Sumif Countif Averageif","index":2,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Monthly Sales Transactions"]
[]
["Sale Date:","Sale Amount:","Commission:"]
["2006-05-01",297700,{"$f":"0.0175*B4","v":5209.7500000000009}]
["2006-05-04",174700,{"$f":"0.025*B5","v":4367.5}]
["2006-05-08",150000,{"$f":"0.025*B6","v":3750}]
["2006-05-11",260600,{"$f":"0.02*B7","v":5212}]
["2006-05-14",444700,{"$f":"0.0175*B8","v":7782.2500000000009}]
["2006-05-17",318100,{"$f":"0.0175*B9","v":5566.7500000000009}]
["2006-05-21",68300,{"$f":"0.025*B10","v":1707.5}]
["2006-05-24",266100,{"$f":"0.02*B11","v":5322}]
["2006-05-27",264300,{"$f":"0.02*B12","v":5286}]
["2006-05-30",395700,{"$f":"0.0175*B13","v":6924.7500000000009}]
[]
[null,"Comm on Sales < £250,000:"]
[null,"Number of Sales < £250,000:"]
[null,"Avg Sales >£250,000:"]

{"sheet":"IF AND","index":3,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Sales Honours List"]
["Previous Fiscal Year"]
[]
["Name:","Years of Service:","Rank:","Volume:","Commission:","Honour:"]
["Tom",10,"Broker",10734650,214693]
["Mary",4,"Broker",13351530,267030.59999999998]
["Pete",6,"Agent",6152140,123042.8]
["Frank",20,"Agent",44303100,886062]
["Lois",6,"Broker",7083920,141678.39999999999]
["Carrie",12,"Broker",12902900,258058]
["Dillon",19,"Agent",40486910,809738.2]
["Perry",13,"Agent",8733820,174676.4]
["Lu-Park",6,"Agent",40228030,804560.6]
["George",1,"Broker",12275120,245502.4]

{"sheet":"IF OR","index":4,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Sales Honours List"]
["Previous Fiscal Year"]
[]
["Name:","Years of Service:","Rank:","Volume:","Commission:","Honour:"]
["Tom",10,"Broker",10734650,214693]
["Mary",4,"Broker",13351530,267030.59999999998]
["Pete",6,"Agent",6152140,123042.8]
["Frank",20,"Agent",44303100,886062]
["Lois",6,"Broker",7083920,141678.39999999999]
["Carrie",12,"Broker",12902900,258058]
["Dillon",19,"Agent",40486910,809738.2]
["Perry",13,"Agent",8733820,174676.4]
["Lu-Park",6,"Agent",40228030,804560.6]
["George",1,"Broker",12275120,245502.4]